AdEnrollRegistration 
Logical Entity Name  AdEnrollRegistration 
Default Table Name  AdEnrollRegistration 
Physical Only  NO 
Definition 
 
Note 
 

AdEnrollRegistration Columns 
ColumnName  Domain  Datatype  NULL  Definition 
AdEnrollRegistrationID    int  NO 
 
AdEnrollID(PK)(FK)    int  NO 
 
AdClassSchedID(PK)(FK)    int  NO 
 
AdTermID(PK)(FK)    int  NO 
 
ReservationExpires    datetime  YES 
 
DateRegistered    datetime  YES 
 
Status    smallint  NO 
 
DateAdded    datetime  NO 
 
DateLstMod    datetime  NO 
 
UserID(FK)    int  NO 
 
WaitListDate    datetime  YES 
 
ResultCode    int  YES 
 
ResultDetail    varchar(800)  YES 
 
ts    timestamp  NO 
 
IsAdvisorApproval    bit  YES 
 
ParentTermId    int  YES 
 
AdCourseStatusChangeReasonID(FK)    int  YES 
 
RetakeFeeWaived    char(1)  NO 
 
Credits    money  YES 
 
Hours    money  YES 
 
PaymentDetails    xml  YES 
 
AdCourseFeeSchedID    int  YES 
 
IsPassFail    char(10)  NO 
 

AdEnrollRegistration Primary and Unique Keys 
Key Name  Key Type  Keys 
AdEnrollRegistration_AdEnrollRegistrationID_U_N_IDX  Index  AdEnrollRegistrationID 
AdEnrollRegistration_AdEnrollID_AdClassSchedID_AdTermID_U_C_IDX  PrimaryKey  AdEnrollID, AdClassSchedID, AdTermID 

AdEnrollRegistration Foreign Keys 
Parent Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype  Not For Replication 
AdClassSched  Identifying  One To Zero or More  FK_AdEnrollRegistration_AdClassSched_AdClassSched_AdClassSchedID      AdClassSchedID  NO  YES 
AdEnroll  Identifying  One To Zero or More  FK_AdEnrollRegistration_AdEnrollID_AdEnroll_AdEnrollID      AdEnrollID  NO  YES 
AdTerm  Identifying  One To Zero or More  FK_AdEnrollRegistration_AdTermID_AdTerm_AdTermID      AdTermID  NO  YES 
SyStaff  Non-Identifying  One To Zero or More  FK_AdEnrollRegistration_UserID_SyStaff_SyStaffID      UserID  NO  YES 
AdCourseStatusChangeReason  Non-Identifying  Zero or One to Zero or More  FK_AdEnrollRegistrationAdCourseStatusChangeReasonID_AdCourseStatusChangeReasonAdCourseStatusChangeReasonID      AdCourseStatusChangeReasonID  NO  YES 
Child Relationships: 
Table Name  Type  Cardinality  Constraint Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype  Not For Replication 
AdEnrollSched  Non-Identifying  One To Zero or More  FK_AdEnrollSched_AdEnrollRegistrationID_AdEnrollRegistration_AdEnrollRegistrationID        NO  YES 

AdEnrollRegistration Check Constraints 
Check Constraint Name  CheckConstraint 
Chk_AdEnrollRegistration_ReservationExpires  ([Status] & 256 = 256 and [ReservationExpires] is not null or [Status] & 256 = 0 and [ReservationExpires] is null)